IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'spTlettertemplate_Update')
	BEGIN
		PRINT 'Dropping Procedure spTlettertemplate_Update'
		DROP  Procedure  spTlettertemplate_Update
	END

GO

PRINT 'Creating Procedure spTlettertemplate_Update'
GO
Create Procedure dbo.spTlettertemplate_Update
	( 	  
		@lettertemplateid int, 
		@lettertemplatename varchar(50), 
		@lettertemplatetype varchar(50), 
		@lettertemplatedescription varchar(8000), 
		@active bit
	)
AS
  /* 
    ------------------------------------------------------------------------------
    - Change History
    - --------------
    - Date          Description
    ------------------------------------------------------------------------------
    - 9/2/2007    Initial version Updated
    ------------------------------------------------------------------------------
  */

	-- Declare the required variables

	-- Update the required new record
	UPDATE Tlettertemplate
	SET
		lettertemplatename = @lettertemplatename, 
		lettertemplatetype = @lettertemplatetype, 
		lettertemplatedescription = @lettertemplatedescription, 
		active = @active		
	WHERE lettertemplateid = @lettertemplateid

	-- Return to calling method
	RETURN
	
GO
